/*
 Navicat Premium Data Transfer

 Source Server         : 我的腾讯云
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : 118.89.121.140:3306
 Source Schema         : ajavaweb

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : 65001

 Date: 23/07/2021 13:55:17
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stu_no` varchar(255) NOT NULL,
  `stu_name` varchar(255) NOT NULL,
  `class_no` int(11) DEFAULT NULL,
  `sex` varchar(20) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `tel` varchar(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `stuno` (`stu_no`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of student
-- ----------------------------
BEGIN;
INSERT INTO `student` VALUES (21, '1832105', '高云飞', 1, '男', 20, '13289447594');
INSERT INTO `student` VALUES (22, '1832106', '高明明', 1, '男', 21, '16058464781');
INSERT INTO `student` VALUES (23, '1832107', '王振宇', 2, '男', 18, '11423981398');
INSERT INTO `student` VALUES (24, '1832108', '郭健', 2, '男', 17, '15944512925');
INSERT INTO `student` VALUES (25, '1832109', '孙雨楠', 3, '女', 18, '16450620704');
INSERT INTO `student` VALUES (26, '1832117', '任奇', 1, '男', 19, '14419565024');
INSERT INTO `student` VALUES (27, '1832118', '金慧清', 1, '女', 20, '11745963282');
INSERT INTO `student` VALUES (28, '1832119', '曹伟', 1, '男', 21, '13471121616');
INSERT INTO `student` VALUES (29, '1832120', '徐婷婷', 1, '女', 23, '13117718508');
INSERT INTO `student` VALUES (30, '1832121', '程玉寒', 1, '男', 22, '18175227970');
INSERT INTO `student` VALUES (31, '1832122', '张玲', 1, '女', 24, '16522984600');
INSERT INTO `student` VALUES (32, '1832123', '王奇峙', 1, '男', 21, '17089239366');
INSERT INTO `student` VALUES (33, '1832124', '刘懿超', 1, '男', 37, '15877243307');
INSERT INTO `student` VALUES (34, '1832110', '徐赟', 1, '男', 31, '17118498712');
INSERT INTO `student` VALUES (35, '1832149', '吴成飞', 1, '男', 28, '17960763918');
INSERT INTO `student` VALUES (36, '1832150', '汪俊', 1, '男', 29, '18448323728');
INSERT INTO `student` VALUES (37, '1832111', '程玮', 1, '男', 20, '18359327161');
INSERT INTO `student` VALUES (38, '1832112', '任文康', 1, '男', 21, '16451664897');
INSERT INTO `student` VALUES (39, '1832113', '马佳豪', 1, '男', 23, '16180343277');
INSERT INTO `student` VALUES (40, '1832125', '石永祥', 1, '男', 24, '11546721974');
INSERT INTO `student` VALUES (41, '1832114', '樊超俊', 1, '男', 25, '16192580311');
INSERT INTO `student` VALUES (42, '1832115', '彭乐翔', 1, '男', 31, '17322735912');
INSERT INTO `student` VALUES (43, '1832116', '尤武辉', 1, '男', 32, '18035938902');
INSERT INTO `student` VALUES (44, '1832126', '鲍天河', 4, '男', 31, '18211487052');
INSERT INTO `student` VALUES (45, '1832127', '李亚豪', 1, '男', 30, '16949618828');
INSERT INTO `student` VALUES (46, '1832128', '马云飞', 1, '男', 22, '19113633261');
INSERT INTO `student` VALUES (47, '1832129', '刘爽', 1, '男', 21, '15719310096');
INSERT INTO `student` VALUES (48, '1832130', '陈国彪', 1, '男', 18, '19255650973');
INSERT INTO `student` VALUES (49, '1832131', '许永杰', 1, '男', 18, '11120324853');
INSERT INTO `student` VALUES (50, '1832132', '张帆', 1, '男', 19, '13834671621');
INSERT INTO `student` VALUES (51, '1832133', '岳丽', 1, '女', 21, '15812383822');
INSERT INTO `student` VALUES (52, '1832134', '舒艺园', 1, '女', 22, '17557904522');
INSERT INTO `student` VALUES (53, '1832135', '袁龙腾', 1, '男', 25, '11352371422');
INSERT INTO `student` VALUES (54, '1832136', '王媚', 1, '女', 24, '11088143818');
INSERT INTO `student` VALUES (55, '1832137', '杨恒', 1, '男', 22, '19383605100');
INSERT INTO `student` VALUES (56, '1832138', '王涛', 1, '男', 24, '16653594324');
INSERT INTO `student` VALUES (57, '1832139', '李颖', 1, '女', 30, '14117156594');
INSERT INTO `student` VALUES (58, '1832140', '王文莉', 1, '女', 21, '18625000274');
INSERT INTO `student` VALUES (59, '1832142', '陈想', 1, '男', 22, '12773531865');
INSERT INTO `student` VALUES (60, '1832143', '董天下', 1, '男', 32, '14992658778');
INSERT INTO `student` VALUES (61, '1832144', '李续龙', 1, '男', 41, '16642698570');
INSERT INTO `student` VALUES (62, '1832145', '梁宏新', 1, '男', 32, '18235516795');
INSERT INTO `student` VALUES (63, '1832146', '朱中民', 1, '男', 21, '12249488539');
INSERT INTO `student` VALUES (64, '1832147', '李延利', 1, '男', 20, '13540892586');
INSERT INTO `student` VALUES (65, '1832148', '李梓衡', 1, '男', 21, '19955997590');
INSERT INTO `student` VALUES (66, '1832141', '王婧', 1, '女', 25, '12157310470');
INSERT INTO `student` VALUES (67, '1831201', '张罗千', 2, '男', 23, '16918559853');
INSERT INTO `student` VALUES (68, '1831202', '范鑫', 2, '男', 21, '19120868134');
INSERT INTO `student` VALUES (69, '1831203', '刘士杰', 2, '男', 12, '15848661386');
INSERT INTO `student` VALUES (71, '1831230', '王相钟', 3, '男', 16, '19880702803');
INSERT INTO `student` VALUES (72, '1831229', '代伟', 2, '男', 17, '13857530135');
INSERT INTO `student` VALUES (73, '1831228', '张亚洲', 2, '男', 18, '16645542542');
INSERT INTO `student` VALUES (74, '1831227', '王晨', 2, '男', 19, '12655122579');
INSERT INTO `student` VALUES (75, '1831226', '刘昌宁', 2, '男', 20, '11338985547');
INSERT INTO `student` VALUES (76, '1831225', '陈宇', 2, '男', 21, '16729560275');
INSERT INTO `student` VALUES (77, '1831224', '王恩辞', 2, '男', 23, '11630845009');
INSERT INTO `student` VALUES (78, '1831223', '舒家兴', 2, '男', 21, '14965544494');
INSERT INTO `student` VALUES (79, '1831222', '姜凯富', 2, '男', 25, '19935187722');
INSERT INTO `student` VALUES (80, '1831221', '童欢', 2, '男', 21, '16779305403');
INSERT INTO `student` VALUES (81, '1831220', '吴映辉', 2, '男', 23, '13090964127');
INSERT INTO `student` VALUES (82, '1831219', '李升升', 2, '男', 24, '13116904701');
INSERT INTO `student` VALUES (83, '1831218', '陈世威', 2, '男', 21, '15311631399');
INSERT INTO `student` VALUES (84, '1831217', '李新', 2, '男', 34, '17207443169');
INSERT INTO `student` VALUES (85, '1831216', '李永朝', 2, '男', 21, '11102321924');
INSERT INTO `student` VALUES (86, '1831215', '施龙燚', 2, '男', 26, '19889280390');
INSERT INTO `student` VALUES (87, '1831214', '王凯旭', 2, '男', 27, '19139436455');
INSERT INTO `student` VALUES (88, '1831231', '张爽', 3, '男', 24, '16029341381');
INSERT INTO `student` VALUES (89, '1831232', '马玉帅', 3, '男', 23, '11728397814');
INSERT INTO `student` VALUES (90, '1831233', '王宏', 3, '男', 24, '17553965204');
INSERT INTO `student` VALUES (91, '1831234', '陈启健', 3, '男', 24, '14584632852');
INSERT INTO `student` VALUES (92, '1831235', '余涛', 3, '男', 25, '18261268927');
INSERT INTO `student` VALUES (93, '1831236', '丁志伟', 3, '男', 25, '18552446352');
INSERT INTO `student` VALUES (94, '1831237', '刘文琰', 3, '男', 26, '17978425258');
INSERT INTO `student` VALUES (95, '1831238', '路银山', 3, '男', 27, '14234787510');
INSERT INTO `student` VALUES (96, '1831239', '张蒙', 3, '女', 25, '15238662054');
INSERT INTO `student` VALUES (97, '1831240', '陶玲', 3, '女', 21, '13488948013');
INSERT INTO `student` VALUES (98, '1831256', '钱金金', 3, '女', 21, '19728754179');
INSERT INTO `student` VALUES (99, '1831255', '王欣雨', 3, '女', 22, '15698373401');
INSERT INTO `student` VALUES (100, '1831254', '张青青', 3, '女', 32, '13698373401');
INSERT INTO `student` VALUES (101, '1831253', '曹雅杰', 3, '男', 21, '18961085883');
INSERT INTO `student` VALUES (102, '1831252', '张冉冉', 3, '女', 36, '17536523829');
INSERT INTO `student` VALUES (103, '1831251', '陈瑜慧', 3, '女', 32, '16626885892');
INSERT INTO `student` VALUES (104, '1831250', '何娟', 3, '女', 23, '19524858248');
INSERT INTO `student` VALUES (105, '1831249', '陈行行', 3, '女', 27, '18743633842');
INSERT INTO `student` VALUES (106, '1831248', '许玲', 3, '女', 26, '15143594742');
INSERT INTO `student` VALUES (107, '1831247', '杨澜', 3, '女', 25, '17487072461');
INSERT INTO `student` VALUES (108, '1831246', '陈慧', 3, '女', 25, '13004578355');
INSERT INTO `student` VALUES (109, '1831245', '高琼', 3, '女', 28, '19561674669');
INSERT INTO `student` VALUES (110, '1831244', '程敏', 3, '女', 29, '13794638553');
INSERT INTO `student` VALUES (111, '1831243', '王妮妮', 3, '女', 28, '16288169036');
INSERT INTO `student` VALUES (112, '1831242', '杜家露', 3, '女', 27, '17056929795');
INSERT INTO `student` VALUES (113, '1831241', '杨逍遥', 3, '女', 26, '16420142143');
INSERT INTO `student` VALUES (114, '1831257', '符倍倍', 3, '女', 34, '19929921607');
INSERT INTO `student` VALUES (115, '1831213', '唐振麟', 2, '男', 32, '15389181882');
INSERT INTO `student` VALUES (116, '1831212', '朱云昊', 2, '男', 21, '18156144866');
INSERT INTO `student` VALUES (117, '1831211', '崔尤龙', 2, '男', 40, '15613178957');
INSERT INTO `student` VALUES (118, '1831210', '应世界', 2, '男', 34, '13597460467');
INSERT INTO `student` VALUES (120, '1831208', '张成明', 2, '男', 32, '12946447560');
INSERT INTO `student` VALUES (121, '1831207', '刘涛', 2, '男', 34, '11288940866');
INSERT INTO `student` VALUES (122, '1831206', '洪高峰', 2, '男', 32, '15605361927');
INSERT INTO `student` VALUES (123, '1831205', '陈文龙', 2, '男', 30, '15159987314');
INSERT INTO `student` VALUES (125, '1000167', '罗永浩', 2, '男', 39, '18738641681');
INSERT INTO `student` VALUES (126, '1000278', '张小花', 3, '女', 39, '15944512086');
COMMIT;

-- ----------------------------
-- Table structure for sys_authority
-- ----------------------------
DROP TABLE IF EXISTS `sys_authority`;
CREATE TABLE `sys_authority` (
  `authority_id` int(11) NOT NULL AUTO_INCREMENT,
  `authority_name` varchar(500) DEFAULT NULL COMMENT '权限名称',
  `menu_url` varchar(500) DEFAULT NULL COMMENT '菜单url',
  `parent_id` int(11) DEFAULT '-1' COMMENT '父id',
  `is_menu` int(11) DEFAULT '1' COMMENT '菜单标记',
  `menu_icon` varchar(500) DEFAULT NULL COMMENT '菜单图标',
  `order_number` int(11) DEFAULT NULL COMMENT '排序字段',
  `create_time` datetime DEFAULT NULL COMMENT '添加时间',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `authority` varchar(500) DEFAULT NULL COMMENT '权限标志',
  PRIMARY KEY (`authority_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COMMENT='权限表';

-- ----------------------------
-- Records of sys_authority
-- ----------------------------
BEGIN;
INSERT INTO `sys_authority` VALUES (6, 'cc', '/cc', -1, 0, '', 11, '2021-07-21 06:15:10', NULL, 'cc');
INSERT INTO `sys_authority` VALUES (7, '日志管理', '/log', -1, 0, '', 2, '2021-07-22 01:11:39', NULL, 'log');
COMMIT;

-- ----------------------------
-- Table structure for sys_manager
-- ----------------------------
DROP TABLE IF EXISTS `sys_manager`;
CREATE TABLE `sys_manager` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(500) DEFAULT NULL COMMENT '用户',
  `pass_word` varchar(500) DEFAULT NULL COMMENT '密码',
  `nick_name` varchar(500) DEFAULT NULL COMMENT '昵称',
  `gender` int(11) DEFAULT '0' COMMENT '0女1男',
  `status` int(11) DEFAULT '0' COMMENT '0未审核1已审核',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `create_by` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
-- Records of sys_manager
-- ----------------------------
BEGIN;
INSERT INTO `sys_manager` VALUES (1, 'zhangsan', '123', '法外狂徒', 1, 1, '2021-07-23 10:22:26', '2021-07-23 10:26:17', NULL);
INSERT INTO `sys_manager` VALUES (2, 'luoxiang', '123', '法外狂徒', 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_manager` VALUES (3, 'qq', 'q', '1q', 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_manager` VALUES (4, 'rr', 'r', 'rr', 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_manager` VALUES (5, 'rr', 'rr', 'rr', 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_manager` VALUES (6, 'tt', 'tt', 'tt', 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_manager` VALUES (7, 'tt', 'tt', 'tt', 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_manager` VALUES (8, 'tt', 'tt', 'tt', 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_manager` VALUES (9, 'tt', 'tt', 'tt', 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_manager` VALUES (10, 'yy', 'yy', 'yy', 1, 0, NULL, NULL, NULL);
INSERT INTO `sys_manager` VALUES (11, 'jack', '7C7D3EB040F8A85E22E3A', 'jack', 1, 0, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_manager_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_manager_role`;
CREATE TABLE `sys_manager_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `manager_id` int(11) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='用户角色关联表';

-- ----------------------------
-- Records of sys_manager_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_manager_role` VALUES (3, 10, 1);
INSERT INTO `sys_manager_role` VALUES (4, 10, 4);
INSERT INTO `sys_manager_role` VALUES (5, 10, 5);
INSERT INTO `sys_manager_role` VALUES (6, 11, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(500) DEFAULT NULL COMMENT '角色名称',
  `comments` varchar(500) DEFAULT NULL COMMENT '备注信息',
  `is_delete` int(11) DEFAULT '0' COMMENT '0未删除1已删除',
  `role_code` varchar(500) DEFAULT NULL COMMENT '角色编码',
  `create_time` datetime DEFAULT NULL COMMENT '添加时间',
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COMMENT='角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, '部门经理', '拥有部分权限', 0, '123', '2021-07-22 08:57:33', '2021-07-22 10:28:44');
INSERT INTO `sys_role` VALUES (4, '总经理', '总经理', 0, '总经理', NULL, NULL);
INSERT INTO `sys_role` VALUES (5, '测试', 'ceshi', 0, '333', NULL, NULL);
INSERT INTO `sys_role` VALUES (6, '测试', 'ceshi', 0, '333', NULL, NULL);
INSERT INTO `sys_role` VALUES (7, '测试', 'ceshi', 0, '333', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_auth
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_auth`;
CREATE TABLE `sys_role_auth` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) DEFAULT NULL COMMENT '角色id',
  `auth_id` int(11) DEFAULT NULL COMMENT '权限id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COMMENT='角色权限关联表';

SET FOREIGN_KEY_CHECKS = 1;
